package com.phiture.erp.produce.dal.mapper;

import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.phiture.erp.produce.dal.entity.ErpMaterialRequirementPlanDO;
import com.phiture.erp.produce.dal.pojo.vo.ErpMaterialRequirementPlanRespVO;
import com.phiture.erp.produce.dal.pojo.vo.ErpMaterialRequirementPlanVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDateTime;

/**
 * 物料需求计划 Mapper
 *
 * @author YH
 */
@Mapper
public interface ErpMaterialRequirementPlanMapper extends BaseMapperX<ErpMaterialRequirementPlanDO> {

    IPage<ErpMaterialRequirementPlanRespVO> pageMaterialRequirementPlan(@Param("page") Page<ErpMaterialRequirementPlanRespVO> page,
                                                                        @Param("sourceBillNo") String sourceBillNo,
                                                                        @Param("mrpNo") String mrpNo,
                                                                        @Param("saleOrderNo") String saleOrderNo,
                                                                        @Param("status") Integer status,
                                                                        @Param("beginTime") LocalDateTime beginTime,
                                                                        @Param("endTime") LocalDateTime endTime);

    ErpMaterialRequirementPlanVO getInfoById(@Param("id") Long id);

}